package cn.gson.fengboot.model.mapper;

import cn.gson.fengboot.model.pojos.Dbusiness;
import cn.gson.fengboot.model.pojos.Dcount;
import cn.gson.fengboot.model.pojos.DmoneyVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface DbusstatiMapper {

    /*折线图我的商机本季度数据*/
    List<Dcount> selectByQUARTERMonthSize(@Param("getbuspeople") String getbuspeople);

    /*折线图我的商机本年数据*/
    List<Dcount> selectByMonthSize(@Param("getbuspeople") String getbuspeople);

    /*折线图过去5年我的商机数据*/
    List<Dcount> selectByyearfiveSize(@Param("getbuspeople") String getbuspeople);

    /*统计阶段数据*/
    List<Dcount> selectByphase(@Param("getbuspeople") String getbuspeople);

    /*统计地图*/
    List<Dcount> selectBySheng(@Param("getbuspeople") String getbuspeople);

    /*我的商机统计饼状图*/
    List<DmoneyVo> selectByMoney(@Param("getbuspeople") String getbuspeople);

    /*我的商机表格本季度*/
    List<Dbusiness> selectByQUARTERData(@Param("getbuspeople") String getbuspeople);

    /*我的商机本年份的商机*/
    List<Dbusiness> selectByYearData(@Param("getbuspeople") String getbuspeople);

    /*我的商机过去5年的商机*/
    List<Dbusiness> selectByFiveYearData(@Param("getbuspeople") String getbuspeople);
}
